<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateWxpaibonesTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('wxpaibones', function(Blueprint $table)
		{
			$table->increments('id');
			$table->date('date');
			$table->string('canp_name');
			$table->integer('total')->default(0);
			$table->integer('gx1_wanc')->default(0);
			$table->integer('gx2_wanc')->default(0);
			$table->integer('gx3_wanc')->default(0);
			$table->integer('gx4_wanc')->default(0);
			$table->integer('gx5_wanc')->default(0);
			$table->integer('gx6_wanc')->default(0);
			$table->string('gx1_1gb')->nullable();
			$table->string('gx1_2gb')->nullable();
			$table->string('gx1_3gb')->nullable();
			$table->string('gx1_4gb')->nullable();
			$table->string('gx2_1gb')->nullable();
			$table->string('gx2_2gb')->nullable();
			$table->string('gx2_3gb')->nullable();
			$table->string('gx2_4gb')->nullable();
			$table->string('gx3_1gb')->nullable();
			$table->string('gx3_2gb')->nullable();
			$table->string('gx3_3gb')->nullable();
			$table->string('gx3_4gb')->nullable();
			$table->string('gx4_1gb')->nullable();
			$table->string('gx4_2gb')->nullable();
			$table->string('gx4_3gb')->nullable();
			$table->string('gx4_4gb')->nullable();
			$table->string('gx5_1gb')->nullable();
			$table->string('gx5_2gb')->nullable();
			$table->string('gx5_3gb')->nullable();
			$table->string('gx5_4gb')->nullable();
			$table->string('gx6_1gb')->nullable();
			$table->string('gx6_2gb')->nullable();
			$table->string('gx6_3gb')->nullable();
			$table->string('gx6_4gb')->nullable();
			$table->string('day_huan')->default('0');
			$table->string('day_has')->default('0');
			$table->timestamps();
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('wxpaibones');
	}

}
